UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JYqtGqfzkN/WQdS77ene97S3nWehIdd8Smmk+z/8aTI='
WHERE
key_id = 'd04a4cce11e5532582f235110c9f8aba7ea074b209858c71bcd4521770ff70e7'
AND (
token = 'JYqtGqfzkN/WQdS77ene97S3nWehIdd8Smmk+z/8aTI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)