UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lW2LjyfiBgkLb+hX54tgC5RnH2xHU9A72+9hPyvZwIs='
WHERE
key_id = '78eae427cec284fb3b3b9791020845f7b75fd1260a604db8db22b79cd270eafe'
AND (
token = 'lW2LjyfiBgkLb+hX54tgC5RnH2xHU9A72+9hPyvZwIs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)