UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kSb1F2mFAuTDGqHZm+NL5Kt103FG730O01jQey3V28I='
WHERE
key_id = '6bab21ddd6875bbe471891a439a23597fc9e1c8c01f8c97be2b65bfe97b53bfa'
AND (
token = 'kSb1F2mFAuTDGqHZm+NL5Kt103FG730O01jQey3V28I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)