UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5KCE4eKlKGerleM20zOrAIpmYL9NKkL22eHs9vglpb4='
WHERE
key_id = '94f248796aba921958ee039173af9893ddac51d39cbe8e9d42523bab8422e342'
AND (
token = '5KCE4eKlKGerleM20zOrAIpmYL9NKkL22eHs9vglpb4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)