UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k4Ha6ESq6eUKsqCpFUGXWhOl/B9h0hGj6ixpW/tOoeA='
WHERE
key_id = 'a8aec488ab71607dfabc4e68595d52f665ef34cb276e70d75432ce7f0846ab67'
AND (
token = 'k4Ha6ESq6eUKsqCpFUGXWhOl/B9h0hGj6ixpW/tOoeA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)