UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RA9+bKplE3rNAWeMo8oNR+IKxY8Ueev4aW1TrPjTm3E='
WHERE
key_id = 'b4dcdb28c0c586f8bcadcca5267cf4df3746abbe7fa2f7efe5e437fea99d4693'
AND (
token = 'RA9+bKplE3rNAWeMo8oNR+IKxY8Ueev4aW1TrPjTm3E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)