UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hDUX4sW918WgeZhXY29+LhDW50z1CQdfyxV2NCub7vY='
WHERE
key_id = '31a4799e5a97d4a62edb1eee0a0712c409f044c25e23da0a416f6e8f03da41f3'
AND (
token = 'hDUX4sW918WgeZhXY29+LhDW50z1CQdfyxV2NCub7vY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)