UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f6Vn/jSMrN8APJtQfIB8hUuScwU9n3WvIiriQNm4+M0='
WHERE
key_id = '97c112b5eb35ab93e81205f57ddef8db6e3cc17241bf3389de5be0653dbe8bb8'
AND (
token = 'f6Vn/jSMrN8APJtQfIB8hUuScwU9n3WvIiriQNm4+M0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)