UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6cgY8alOsqcyZ4+cFYBzdZoV5CQmLixwALNHScSe9CY='
WHERE
key_id = '900c6c40e55d3faf85b34ca5b9acb1db90eec4f2c9e0f9e57f5a6e9b2520ff5f'
AND (
token = '6cgY8alOsqcyZ4+cFYBzdZoV5CQmLixwALNHScSe9CY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)