UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AqgLF/og2a0wJT/kSqdKAaomo3Ov7EnIn15NbDCplQA='
WHERE
key_id = '7f02b1701935957c24814ffd795ddb27e99c43fdde6c9974f1b4227a52a536bb'
AND (
token = 'AqgLF/og2a0wJT/kSqdKAaomo3Ov7EnIn15NbDCplQA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)