UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o8DsNkH8Pu8hP7gLYNT9U3nEtIaTQkHajG33A/9cO5k='
WHERE
key_id = 'a4e8ebd986ce28e773fd439d4f625f4fae148085f3feea9144940ee1af59e261'
AND (
token = 'o8DsNkH8Pu8hP7gLYNT9U3nEtIaTQkHajG33A/9cO5k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)