UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KtKsF25zX6pOMxVA8f8HDwYqbjdfBVWahH+t3M+CKfw='
WHERE
key_id = '0cccdd3f54087aa7b766cfd318b0deac6faaaf52aa5c7cd39ff681d3491df454'
AND (
token = 'KtKsF25zX6pOMxVA8f8HDwYqbjdfBVWahH+t3M+CKfw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)