UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4xACpjseF25xNn9m7OmC4sXugPvcEwpXX9fbuE1lGR8='
WHERE
key_id = '376212632ac16d12aca845b2af73d90341f78e4f50f8d501307181f130bfe816'
AND (
token = '4xACpjseF25xNn9m7OmC4sXugPvcEwpXX9fbuE1lGR8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)