UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Ik9R9oWl6Rm0nbRr4agRWeaDA0TuPs7x5WTH2j/ISw='
WHERE
key_id = 'dc96ca69ec44bf62fd3157d0d0e4bd26968e1c3418270c6685c40c711b169d60'
AND (
token = '1Ik9R9oWl6Rm0nbRr4agRWeaDA0TuPs7x5WTH2j/ISw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)