UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K8UckTwspBz8N1/YhOOI9vqjUieWaPVO8anLyAloelg='
WHERE
key_id = 'f58b00062d1166922a381350e907c9a7342ff2fa527650a92fe3e2e03922cf59'
AND (
token = 'K8UckTwspBz8N1/YhOOI9vqjUieWaPVO8anLyAloelg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)