UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cpej5lMH7viGE3righct7d+/+ongNnXhEt6CDFg0J2Q='
WHERE
key_id = 'd46004d2ad19e5bdece8f6cf457d931fde5e1a523854fc39001d26208a16aff2'
AND (
token = 'cpej5lMH7viGE3righct7d+/+ongNnXhEt6CDFg0J2Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)