UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qfogUqc5TdWj8q5ZhyrDWPrcM1vPgOsfiVGlcEc/22Q='
WHERE
key_id = 'b4d10fe230e70b7f9a42a8ce72f9dd0b0e42534a6ad99969012bf5980f0f38d7'
AND (
token = 'qfogUqc5TdWj8q5ZhyrDWPrcM1vPgOsfiVGlcEc/22Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)