UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Np5fgEas4ZjtVWFxHABso4F03U6GIj6hCBEnJCO0Sg='
WHERE
key_id = 'c6e619d0722af77c1e756a82b7bb37a075b8711e50e5c9915597306f2b600e93'
AND (
token = '0Np5fgEas4ZjtVWFxHABso4F03U6GIj6hCBEnJCO0Sg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)