UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hC2oXGl0y6hRoSgs4QkvsWBQ5kdb7Z10onIsLT77sPQ='
WHERE
key_id = '4aca931adc7fe112c36328bb36be823df25d2ce844536daccf78518cee58460f'
AND (
token = 'hC2oXGl0y6hRoSgs4QkvsWBQ5kdb7Z10onIsLT77sPQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)