UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c63L2bHBibAcm/RJQbO8d3xzREFXQN/79jvNktdZjfc='
WHERE
key_id = 'd1ddfcbb5c76178fd2d8c95d496ac1eb85c27aaa54fd08f9a12577a07e49ee5a'
AND (
token = 'c63L2bHBibAcm/RJQbO8d3xzREFXQN/79jvNktdZjfc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)