UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oLVriGjG5Q2ExfrSfP8uniZ21QrufI8dMOxJ4SJOwIA='
WHERE
key_id = 'e4af951b1c3053865ae8a1e4334cb7148158b7d388500f2daf0d7c0679138b54'
AND (
token = 'oLVriGjG5Q2ExfrSfP8uniZ21QrufI8dMOxJ4SJOwIA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)