UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bUGFXPKXRczPjoHhwKDhtKX93rU+bwtMjbB3s2XIuwA='
WHERE
key_id = 'f6864b5c4cbdf9ba77ebdaa518f7ed7894cf2ba09ae8f7ec100e7f916f0c4a99'
AND (
token = 'bUGFXPKXRczPjoHhwKDhtKX93rU+bwtMjbB3s2XIuwA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)