UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'johrhWuT+ijx1qOic6OJgElasn9q4w3kAw+6W3ibQYI='
WHERE
key_id = '102081b2c5a5f20d94c941cb6fd42df94fba56f2aaa0d4efd4fb2ad4629bbcae'
AND (
token = 'johrhWuT+ijx1qOic6OJgElasn9q4w3kAw+6W3ibQYI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)