UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bPfK8whkj7w3FpNp6byAd7gZ5a2NmXhJu1XH9wnPIiE='
WHERE
key_id = 'e7d5cf1aa6f9a73eed917eabd4014c3bd0ec49dc680cb85e9b2834ab690e90fb'
AND (
token = 'bPfK8whkj7w3FpNp6byAd7gZ5a2NmXhJu1XH9wnPIiE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)