UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UAkpZan32IqXt39nTqarpqzJpmQucp/oZf2jkjvfPWA='
WHERE
key_id = 'b1fefa1365b9662ba3f75236d3b88bdd82c0f3ab60b096c27c4d8720f795151d'
AND (
token = 'UAkpZan32IqXt39nTqarpqzJpmQucp/oZf2jkjvfPWA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)