UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'msayboNRIqETCQppAIuJhrru3xS6wl5abS5uiK1ATfI='
WHERE
key_id = 'de323b1d4f5dd28b64380da2c5725cfd543c984aa555b9275f78c3a3932258ef'
AND (
token = 'msayboNRIqETCQppAIuJhrru3xS6wl5abS5uiK1ATfI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)