UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lg8UxRjVlYCywK8QAq+6bz61Q1yaEk9BbeqWl++EyfQ='
WHERE
key_id = 'bf9a50641c51106805a39a126716e8e14f5bee45be7f72a985de6122bf23da1f'
AND (
token = 'Lg8UxRjVlYCywK8QAq+6bz61Q1yaEk9BbeqWl++EyfQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)