UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g1tUvM/+u954IaY/ss5yf/JlouzZolN+EG3tl93vhIs='
WHERE
key_id = 'ba805b80e735af7bff7b86df8105e4d0375eee0303cad52c596a39f2f8f795b4'
AND (
token = 'g1tUvM/+u954IaY/ss5yf/JlouzZolN+EG3tl93vhIs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)