UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SqCYAsCx8a8S++wPbxMEDdHuofSQD1YVrG1zH2Zq/rU='
WHERE
key_id = 'a6acc69e582efda57a9a42ce3b30f9c24b747a4ef66d90d31419ba88f82b3fce'
AND (
token = 'SqCYAsCx8a8S++wPbxMEDdHuofSQD1YVrG1zH2Zq/rU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)