UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BHLfGRLMLXdsx7y8NMjk2hU3Cj59f/Xt60L2Uigr3bk='
WHERE
key_id = 'caf12edc8ff6e536863a0cec65b2407cf04acabbc3d6c11e06c53fc6acc51fdc'
AND (
token = 'BHLfGRLMLXdsx7y8NMjk2hU3Cj59f/Xt60L2Uigr3bk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)