UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HCSi83U2SXgQcTdnL/7Gh7bnYh6EI1lmm4iSbN3L2/A='
WHERE
key_id = '0cb41a5e6910576d82938df3c928d8cfbdd35a100622792dba640dbf2b0b5420'
AND (
token = 'HCSi83U2SXgQcTdnL/7Gh7bnYh6EI1lmm4iSbN3L2/A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)