UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1apyp8T5heHwq8sdGwupfOibYnTA7tNy4tKVJzqdU0E='
WHERE
key_id = '3ca412e8f28e13941bdf3447a78156e5bf4d0bc08c3cb126eb8a7ac69b5e5e63'
AND (
token = '1apyp8T5heHwq8sdGwupfOibYnTA7tNy4tKVJzqdU0E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)