UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cposkCyh8hl4wGM858yz+VJ+WuX7lRzammaPY5KeXaU='
WHERE
key_id = '836a54b793b2f076375607ff48f1e75f8009aef8bea50fc6ae59dae49bfb31d8'
AND (
token = 'cposkCyh8hl4wGM858yz+VJ+WuX7lRzammaPY5KeXaU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)