UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7OC7eSXfnG3PbC9EfsxyCtrDwH5t5/QSt56oFTY/hN4='
WHERE
key_id = 'f6eecd6cbc8a123f303c514049f1fce8794ec535252fe1ab6f1188ea3e1d4d0b'
AND (
token = '7OC7eSXfnG3PbC9EfsxyCtrDwH5t5/QSt56oFTY/hN4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)