UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OfGBqfn60iZ79n2PbD1D8k1zAli9X19QZq6d/wAMI+s='
WHERE
key_id = '0f5ecd806e07b11037a830a098f687e502891abcbab73ce21179cfba1c28ae6a'
AND (
token = 'OfGBqfn60iZ79n2PbD1D8k1zAli9X19QZq6d/wAMI+s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)