UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zMnBFa/2KsNffZUgmmnvEczPqce7yErFR9idKOOsisM='
WHERE
key_id = '6fedc047e24e10c00beb9068051fad4367f975f4354934f39e42ad026e62e6dc'
AND (
token = 'zMnBFa/2KsNffZUgmmnvEczPqce7yErFR9idKOOsisM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)